Root Zanli
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
o5t6x7pgljbm
/
public_html
/
admin
/
storage
/
logs
/
Filename :
sql-2025-09-10.log
back
Copy
[2025-09-10 03:57:20] local.INFO: SQL: select * from `admin` where `email` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [aman@coinsforcollege.org] | Time: 7.17ms [2025-09-10 03:57:20] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [3, App\Models\Admin] | Time: 4.96ms [2025-09-10 03:57:20] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [3] | Time: 3.96ms [2025-09-10 03:57:20] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [3, App\Models\Admin] | Time: 0.55ms [2025-09-10 03:57:20] local.INFO: SQL: select count(*) as aggregate from `users` where `users`.`deleted_at` is null | Bindings: [] | Time: 10.23ms [2025-09-10 03:57:20] local.INFO: SQL: select count(*) as aggregate from `products` where `products`.`deleted_at` is null | Bindings: [] | Time: 10.04ms [2025-09-10 03:57:20] local.INFO: SQL: select count(*) as aggregate from `product_categories` where `product_categories`.`deleted_at` is null | Bindings: [] | Time: 1.94ms [2025-09-10 03:57:20] local.INFO: SQL: select count(*) as aggregate from `countries` where `countries`.`deleted_at` is null | Bindings: [] | Time: 2.36ms [2025-09-10 03:57:20] local.INFO: SQL: select count(*) as aggregate from `goals` where `goals`.`deleted_at` is null | Bindings: [] | Time: 1.95ms [2025-09-10 03:57:20] local.INFO: SQL: select count(*) as aggregate from `groups` where `groups`.`deleted_at` is null | Bindings: [] | Time: 10.25ms [2025-09-10 03:57:20] local.INFO: SQL: select count(*) as aggregate from `tasks` where `tasks`.`deleted_at` is null | Bindings: [] | Time: 11.4ms [2025-09-10 03:57:20] local.INFO: SQL: select count(*) as aggregate from `colleges` where `colleges`.`deleted_at` is null | Bindings: [] | Time: 8.47ms [2025-09-10 03:57:20] local.INFO: SQL: select count(*) as aggregate from `courses` where `courses`.`deleted_at` is null | Bindings: [] | Time: 2.22ms [2025-09-10 03:57:20] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [3, App\Models\Admin] | Time: 0.7ms [2025-09-10 03:57:20] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [3, App\Models\Admin] | Time: 0.7ms [2025-09-10 03:57:27] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [3] | Time: 3.13ms [2025-09-10 03:57:27] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [3, App\Models\Admin] | Time: 0.45ms [2025-09-10 03:57:27] local.INFO: SQL: select * from `admin` where exists (select * from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `admin`.`admin_id` = `role_user`.`user_id` and `role_user`.`user_type` = ? and `name` in (?)) and `admin`.`deleted_at` is null | Bindings: [App\Models\Admin, SCHOOL_ADMIN] | Time: 1.59ms [2025-09-10 03:57:27] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [3, App\Models\Admin] | Time: 0.35ms [2025-09-10 03:57:27] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [3, App\Models\Admin] | Time: 0.33ms [2025-09-10 03:57:28] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [3] | Time: 9.52ms [2025-09-10 03:57:28] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [3, App\Models\Admin] | Time: 2.46ms [2025-09-10 03:57:28] local.INFO: SQL: select count(*) as aggregate from `admin` where `admin`.`deleted_at` is null | Bindings: [] | Time: 0.61ms [2025-09-10 03:57:28] local.INFO: SQL: select `admin`.`name`, `admin`.`email`, `admin`.`admin_id` from `admin` where exists (select * from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `admin`.`admin_id` = `role_user`.`user_id` and `role_user`.`user_type` = ? and `name` in (?)) and `admin`.`deleted_at` is null | Bindings: [App\Models\Admin, SCHOOL_ADMIN] | Time: 0.68ms [2025-09-10 03:57:28] local.INFO: SQL: select `admin`.`name`, `admin`.`email`, `admin`.`admin_id` from `admin` where exists (select * from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `admin`.`admin_id` = `role_user`.`user_id` and `role_user`.`user_type` = ? and `name` in (?)) and `admin`.`deleted_at` is null order by `admin`.`created_at` desc limit 10 offset 0 | Bindings: [App\Models\Admin, SCHOOL_ADMIN] | Time: 0.72ms [2025-09-10 03:57:38] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [3] | Time: 3.69ms [2025-09-10 03:57:55] local.INFO: SQL: select * from `admin` where `email` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [aman@school.com] | Time: 18.63ms [2025-09-10 03:57:56] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.95ms [2025-09-10 03:57:56] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 1.34ms [2025-09-10 03:57:56] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 4.97ms [2025-09-10 03:57:56] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.98ms [2025-09-10 03:57:56] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 7.1ms [2025-09-10 03:57:56] local.INFO: SQL: select `name`, `admin_id` from `admin` where exists (select * from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `admin`.`admin_id` = `role_user`.`user_id` and `role_user`.`user_type` = ? and `name` in (?)) and exists (select * from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin`.`admin_id` = `admin_school`.`admin_id` and `schools`.`school_id` = ? and `schools`.`deleted_at` is null) and `admin`.`deleted_at` is null | Bindings: [App\Models\Admin, SCHOOL_ADMIN, 2] | Time: 2.12ms [2025-09-10 03:57:56] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 2.64ms [2025-09-10 03:57:56] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.78ms [2025-09-10 03:57:56] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 3.98ms [2025-09-10 03:57:56] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 10.5ms [2025-09-10 03:57:58] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 11.31ms [2025-09-10 03:57:58] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 20.83ms [2025-09-10 03:57:58] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.86ms [2025-09-10 03:57:58] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 9.75ms [2025-09-10 03:57:58] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.62ms [2025-09-10 03:57:58] local.INFO: SQL: select `user_id` from `users` where `preferred_school_id` = ? and `users`.`deleted_at` is null | Bindings: [2] | Time: 1.15ms [2025-09-10 03:57:58] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 5.31ms [2025-09-10 03:57:58] local.INFO: SQL: select `user_id` from `users` where `preferred_school_id` = ? and `users`.`deleted_at` is null | Bindings: [2] | Time: 0.95ms [2025-09-10 03:57:58] local.INFO: SQL: select * from `calendars` where `group_id` = ? limit 1 | Bindings: [-1] | Time: 2.07ms [2025-09-10 03:57:58] local.INFO: SQL: select * from `users` where 0 = 1 and `users`.`deleted_at` is null | Bindings: [] | Time: 0.52ms [2025-09-10 03:57:58] local.INFO: SQL: select * from `calendars` where `group_id` = ? limit 1 | Bindings: [-1] | Time: 0.66ms [2025-09-10 03:57:58] local.INFO: SQL: select * from `users` where 0 = 1 and `users`.`deleted_at` is null | Bindings: [] | Time: 0.37ms [2025-09-10 03:57:58] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 33.22ms [2025-09-10 03:57:58] local.INFO: SQL: select `attendances`.`attendance_id`, `attendances`.`user_id`, `attendances`.`group_id`, `attendances`.`date`, `attendances`.`present`, `attendances`.`holiday`, `attendances`.`attendance_updated_by_type`, `attendances`.`attendance_updated_by_id`, `attendances`.`created_at`, `attendances`.`updated_at`, `attendances`.`deleted_at` from `attendances` inner join (select `attendance_id`, `user_id`, `group_id`, `date`, FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') AS priority, ROW_NUMBER() OVER (PARTITION BY user_id, `date` ORDER BY FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') ASC) AS row_number from `attendances` where 0 = 1 and `group_id` in (?, ?) and `date` between ? and ? and `attendances`.`deleted_at` is null) as `sub` on `attendances`.`attendance_id` = `sub`.`attendance_id` where `row_number` = ? and `attendances`.`deleted_at` is null | Bindings: [-1, , 2024-10-01, 2024-10-31, 1] | Time: 2.29ms [2025-09-10 03:57:58] local.INFO: SQL: select `attendances`.`attendance_id`, `attendances`.`user_id`, `attendances`.`group_id`, `attendances`.`date`, `attendances`.`present`, `attendances`.`holiday`, `attendances`.`attendance_updated_by_type`, `attendances`.`attendance_updated_by_id`, `attendances`.`created_at`, `attendances`.`updated_at`, `attendances`.`deleted_at` from `attendances` inner join (select `attendance_id`, `user_id`, `group_id`, `date`, FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') AS priority, ROW_NUMBER() OVER (PARTITION BY user_id, `date` ORDER BY FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') ASC) AS row_number from `attendances` where 0 = 1 and `group_id` in (?, ?) and `date` between ? and ? and `attendances`.`deleted_at` is null) as `sub` on `attendances`.`attendance_id` = `sub`.`attendance_id` where `row_number` = ? and `attendances`.`deleted_at` is null | Bindings: [-1, , 2025-07-02, 2025-07-08, 1] | Time: 2.34ms [2025-09-10 03:57:58] local.INFO: SQL: select `date` from `holidays` where `calendar_id` = ? and `date` between ? and ? | Bindings: [100, 2025-07-02, 2025-07-08] | Time: 47.28ms [2025-09-10 03:57:58] local.INFO: SQL: select `date` from `holidays` where `calendar_id` = ? and `date` between ? and ? | Bindings: [100, 2024-10-01, 2024-10-31] | Time: 48.8ms [2025-09-10 03:57:58] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 16.29ms [2025-09-10 03:57:58] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 7.99ms [2025-09-10 03:57:58] local.INFO: SQL: select `user_id` from `users` where `preferred_school_id` = ? and `users`.`deleted_at` is null | Bindings: [2] | Time: 0.55ms [2025-09-10 03:57:58] local.INFO: SQL: select * from `calendars` where `group_id` = ? limit 1 | Bindings: [-1] | Time: 0.45ms [2025-09-10 03:57:58] local.INFO: SQL: select * from `users` where 0 = 1 and `users`.`deleted_at` is null | Bindings: [] | Time: 0.48ms [2025-09-10 03:57:58] local.INFO: SQL: select `attendances`.`attendance_id`, `attendances`.`user_id`, `attendances`.`group_id`, `attendances`.`date`, `attendances`.`present`, `attendances`.`holiday`, `attendances`.`attendance_updated_by_type`, `attendances`.`attendance_updated_by_id`, `attendances`.`created_at`, `attendances`.`updated_at`, `attendances`.`deleted_at` from `attendances` inner join (select `attendance_id`, `user_id`, `group_id`, `date`, FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') AS priority, ROW_NUMBER() OVER (PARTITION BY user_id, `date` ORDER BY FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') ASC) AS row_number from `attendances` where 0 = 1 and `group_id` in (?, ?) and `date` between ? and ? and `attendances`.`deleted_at` is null) as `sub` on `attendances`.`attendance_id` = `sub`.`attendance_id` where `row_number` = ? and `attendances`.`deleted_at` is null | Bindings: [-1, , 2025-08-27, 2025-08-27, 1] | Time: 1.02ms [2025-09-10 03:57:58] local.INFO: SQL: select `date` from `holidays` where `calendar_id` = ? and `date` between ? and ? | Bindings: [100, 2025-08-27, 2025-08-27] | Time: 0.54ms [2025-09-10 03:58:03] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 4.33ms [2025-09-10 03:58:03] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.64ms [2025-09-10 03:58:03] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.35ms [2025-09-10 03:58:03] local.INFO: SQL: select `users`.`full_name`, `users`.`email`, `users`.`mobile`, `users`.`profile_pic`, `users`.`user_id` from `users` where `preferred_school_id` = ? and `users`.`deleted_at` is null limit 10 offset 0 | Bindings: [2] | Time: 0.94ms [2025-09-10 03:58:03] local.INFO: SQL: select * from `student_segments` where `school_id` = ? and `student_segments`.`deleted_at` is null | Bindings: [2] | Time: 1.7ms [2025-09-10 03:58:03] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.43ms [2025-09-10 03:58:03] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.38ms [2025-09-10 03:58:04] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 3.49ms [2025-09-10 03:58:04] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 3.6ms [2025-09-10 03:58:04] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.42ms [2025-09-10 03:58:04] local.INFO: SQL: select count(*) as aggregate from `users` left join `student_segment_user` on `users`.`user_id` = `student_segment_user`.`user_id` and `student_segment_user`.`deleted_at` is null left join `student_segments` on `student_segment_user`.`student_segment_id` = `student_segments`.`id` and `student_segments`.`deleted_at` is null where `users`.`preferred_school_id` = ? and `users`.`deleted_at` is null group by `users`.`user_id` | Bindings: [2] | Time: 2.25ms [2025-09-10 03:58:04] local.INFO: SQL: select `users`.`full_name`, `users`.`email`, `users`.`mobile`, `users`.`profile_pic`, `users`.`user_id`, GROUP_CONCAT(student_segments.name SEPARATOR ", ") as segment_names from `users` left join `student_segment_user` on `users`.`user_id` = `student_segment_user`.`user_id` and `student_segment_user`.`deleted_at` is null left join `student_segments` on `student_segment_user`.`student_segment_id` = `student_segments`.`id` and `student_segments`.`deleted_at` is null where `users`.`preferred_school_id` = ? and `users`.`deleted_at` is null group by `users`.`user_id` limit 10 offset 0 | Bindings: [2] | Time: 0.73ms [2025-09-10 03:58:07] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 2.91ms [2025-09-10 03:58:07] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.47ms [2025-09-10 03:58:07] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.31ms [2025-09-10 03:58:07] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.34ms [2025-09-10 03:58:07] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.3ms [2025-09-10 03:58:07] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 15.19ms [2025-09-10 03:58:07] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 1.59ms [2025-09-10 03:58:07] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.43ms [2025-09-10 03:58:07] local.INFO: SQL: select count(*) as aggregate from `student_segments` where `school_id` = ? and `student_segments`.`deleted_at` is null | Bindings: [2] | Time: 0.73ms [2025-09-10 03:58:07] local.INFO: SQL: select * from `student_segments` where `school_id` = ? and `student_segments`.`deleted_at` is null limit 10 offset 0 | Bindings: [2] | Time: 0.58ms [2025-09-10 03:58:10] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 5.77ms [2025-09-10 03:58:10] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.72ms [2025-09-10 03:58:10] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.57ms [2025-09-10 03:58:10] local.INFO: SQL: select `name`, `admin_id` from `admin` where exists (select * from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `admin`.`admin_id` = `role_user`.`user_id` and `role_user`.`user_type` = ? and `name` in (?)) and exists (select * from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin`.`admin_id` = `admin_school`.`admin_id` and `schools`.`school_id` = ? and `schools`.`deleted_at` is null) and `admin`.`deleted_at` is null | Bindings: [App\Models\Admin, SCHOOL_ADMIN, 2] | Time: 0.83ms [2025-09-10 03:58:10] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.52ms [2025-09-10 03:58:10] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.39ms [2025-09-10 03:58:10] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.32ms [2025-09-10 03:58:10] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.35ms [2025-09-10 03:58:10] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 3.27ms [2025-09-10 03:58:10] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 2.19ms [2025-09-10 03:58:11] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 2.42ms [2025-09-10 03:58:11] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 2.48ms [2025-09-10 03:58:11] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.47ms [2025-09-10 03:58:11] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.6ms [2025-09-10 03:58:11] local.INFO: SQL: select `user_id` from `users` where `preferred_school_id` = ? and `users`.`deleted_at` is null | Bindings: [2] | Time: 0.26ms [2025-09-10 03:58:11] local.INFO: SQL: select `user_id` from `users` where `preferred_school_id` = ? and `users`.`deleted_at` is null | Bindings: [2] | Time: 0.29ms [2025-09-10 03:58:11] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 2.94ms [2025-09-10 03:58:11] local.INFO: SQL: select * from `calendars` where `group_id` = ? limit 1 | Bindings: [-1] | Time: 0.32ms [2025-09-10 03:58:11] local.INFO: SQL: select * from `calendars` where `group_id` = ? limit 1 | Bindings: [-1] | Time: 0.6ms [2025-09-10 03:58:11] local.INFO: SQL: select * from `users` where 0 = 1 and `users`.`deleted_at` is null | Bindings: [] | Time: 0.37ms [2025-09-10 03:58:11] local.INFO: SQL: select * from `users` where 0 = 1 and `users`.`deleted_at` is null | Bindings: [] | Time: 0.46ms [2025-09-10 03:58:11] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.59ms [2025-09-10 03:58:11] local.INFO: SQL: select `attendances`.`attendance_id`, `attendances`.`user_id`, `attendances`.`group_id`, `attendances`.`date`, `attendances`.`present`, `attendances`.`holiday`, `attendances`.`attendance_updated_by_type`, `attendances`.`attendance_updated_by_id`, `attendances`.`created_at`, `attendances`.`updated_at`, `attendances`.`deleted_at` from `attendances` inner join (select `attendance_id`, `user_id`, `group_id`, `date`, FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') AS priority, ROW_NUMBER() OVER (PARTITION BY user_id, `date` ORDER BY FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') ASC) AS row_number from `attendances` where 0 = 1 and `group_id` in (?, ?) and `date` between ? and ? and `attendances`.`deleted_at` is null) as `sub` on `attendances`.`attendance_id` = `sub`.`attendance_id` where `row_number` = ? and `attendances`.`deleted_at` is null | Bindings: [-1, , 2025-07-02, 2025-07-08, 1] | Time: 0.56ms [2025-09-10 03:58:11] local.INFO: SQL: select `attendances`.`attendance_id`, `attendances`.`user_id`, `attendances`.`group_id`, `attendances`.`date`, `attendances`.`present`, `attendances`.`holiday`, `attendances`.`attendance_updated_by_type`, `attendances`.`attendance_updated_by_id`, `attendances`.`created_at`, `attendances`.`updated_at`, `attendances`.`deleted_at` from `attendances` inner join (select `attendance_id`, `user_id`, `group_id`, `date`, FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') AS priority, ROW_NUMBER() OVER (PARTITION BY user_id, `date` ORDER BY FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') ASC) AS row_number from `attendances` where 0 = 1 and `group_id` in (?, ?) and `date` between ? and ? and `attendances`.`deleted_at` is null) as `sub` on `attendances`.`attendance_id` = `sub`.`attendance_id` where `row_number` = ? and `attendances`.`deleted_at` is null | Bindings: [-1, , 2025-08-27, 2025-08-27, 1] | Time: 0.63ms [2025-09-10 03:58:11] local.INFO: SQL: select `date` from `holidays` where `calendar_id` = ? and `date` between ? and ? | Bindings: [100, 2025-07-02, 2025-07-08] | Time: 0.27ms [2025-09-10 03:58:11] local.INFO: SQL: select `date` from `holidays` where `calendar_id` = ? and `date` between ? and ? | Bindings: [100, 2025-08-27, 2025-08-27] | Time: 0.34ms [2025-09-10 03:58:11] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.54ms [2025-09-10 03:58:11] local.INFO: SQL: select `user_id` from `users` where `preferred_school_id` = ? and `users`.`deleted_at` is null | Bindings: [2] | Time: 0.57ms [2025-09-10 03:58:11] local.INFO: SQL: select * from `calendars` where `group_id` = ? limit 1 | Bindings: [-1] | Time: 0.44ms [2025-09-10 03:58:11] local.INFO: SQL: select * from `users` where 0 = 1 and `users`.`deleted_at` is null | Bindings: [] | Time: 0.38ms [2025-09-10 03:58:11] local.INFO: SQL: select `attendances`.`attendance_id`, `attendances`.`user_id`, `attendances`.`group_id`, `attendances`.`date`, `attendances`.`present`, `attendances`.`holiday`, `attendances`.`attendance_updated_by_type`, `attendances`.`attendance_updated_by_id`, `attendances`.`created_at`, `attendances`.`updated_at`, `attendances`.`deleted_at` from `attendances` inner join (select `attendance_id`, `user_id`, `group_id`, `date`, FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') AS priority, ROW_NUMBER() OVER (PARTITION BY user_id, `date` ORDER BY FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') ASC) AS row_number from `attendances` where 0 = 1 and `group_id` in (?, ?) and `date` between ? and ? and `attendances`.`deleted_at` is null) as `sub` on `attendances`.`attendance_id` = `sub`.`attendance_id` where `row_number` = ? and `attendances`.`deleted_at` is null | Bindings: [-1, , 2024-10-01, 2024-10-31, 1] | Time: 0.64ms [2025-09-10 03:58:11] local.INFO: SQL: select `date` from `holidays` where `calendar_id` = ? and `date` between ? and ? | Bindings: [100, 2024-10-01, 2024-10-31] | Time: 0.43ms [2025-09-10 03:58:14] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 2.76ms [2025-09-10 03:58:14] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.38ms [2025-09-10 03:58:14] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.26ms [2025-09-10 03:58:14] local.INFO: SQL: select * from `users` where exists (select * from `schools` where `users`.`preferred_school_id` = `schools`.`school_id` and `preferred_school_id` = ? and `schools`.`deleted_at` is null) and `users`.`deleted_at` is null | Bindings: [2] | Time: 1.2ms [2025-09-10 03:58:14] local.INFO: SQL: select * from `users` where 0 = 1 and `users`.`deleted_at` is null | Bindings: [] | Time: 0.26ms [2025-09-10 03:58:14] local.INFO: SQL: select * from `calendars` where `group_id` = ? limit 1 | Bindings: [-1] | Time: 0.24ms [2025-09-10 03:58:14] local.INFO: SQL: select `attendances`.`attendance_id`, `attendances`.`user_id`, `attendances`.`group_id`, `attendances`.`date`, `attendances`.`present`, `attendances`.`holiday`, `attendances`.`attendance_updated_by_type`, `attendances`.`attendance_updated_by_id`, `attendances`.`created_at`, `attendances`.`updated_at`, `attendances`.`deleted_at` from `attendances` inner join (select `attendance_id`, `user_id`, `group_id`, `date`, FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') AS priority, ROW_NUMBER() OVER (PARTITION BY user_id, `date` ORDER BY FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') ASC) AS row_no from `attendances` where 0 = 1 and `group_id` in (?, ?) and `date` between ? and ? and `attendances`.`deleted_at` is null) as `sub` on `attendances`.`attendance_id` = `sub`.`attendance_id` where `sub`.`row_no` = ? and `attendances`.`deleted_at` is null | Bindings: [-1, -1, 2025-09-08 00:00:00, 2025-09-14 23:59:59, 1] | Time: 0.62ms [2025-09-10 03:58:14] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.33ms [2025-09-10 03:58:14] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.26ms [2025-09-10 03:58:17] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 4.62ms [2025-09-10 03:58:17] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.53ms [2025-09-10 03:58:17] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.44ms [2025-09-10 03:58:17] local.INFO: SQL: select * from `users` where exists (select * from `schools` where `users`.`preferred_school_id` = `schools`.`school_id` and `preferred_school_id` = ? and `schools`.`deleted_at` is null) and `users`.`deleted_at` is null | Bindings: [2] | Time: 0.63ms [2025-09-10 03:58:17] local.INFO: SQL: select * from `users` where 0 = 1 and `users`.`deleted_at` is null | Bindings: [] | Time: 0.32ms [2025-09-10 03:58:17] local.INFO: SQL: select * from `calendars` where `group_id` = ? limit 1 | Bindings: [-1] | Time: 0.47ms [2025-09-10 03:58:17] local.INFO: SQL: select `attendances`.`attendance_id`, `attendances`.`user_id`, `attendances`.`group_id`, `attendances`.`date`, `attendances`.`present`, `attendances`.`holiday`, `attendances`.`attendance_updated_by_type`, `attendances`.`attendance_updated_by_id`, `attendances`.`created_at`, `attendances`.`updated_at`, `attendances`.`deleted_at` from `attendances` inner join (select `attendance_id`, `user_id`, `group_id`, `date`, FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') AS priority, ROW_NUMBER() OVER (PARTITION BY user_id, `date` ORDER BY FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') ASC) AS row_no from `attendances` where 0 = 1 and `group_id` in (?, ?) and `date` between ? and ? and `attendances`.`deleted_at` is null) as `sub` on `attendances`.`attendance_id` = `sub`.`attendance_id` where `sub`.`row_no` = ? and `attendances`.`deleted_at` is null | Bindings: [-1, -1, 2025-09-08 00:00:00, 2025-09-14 23:59:59, 1] | Time: 0.85ms [2025-09-10 03:58:17] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.49ms [2025-09-10 03:58:17] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.48ms [2025-09-10 03:58:18] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 7.89ms [2025-09-10 03:58:18] local.INFO: SQL: select * from `admin` where `admin_id` = ? and `admin`.`deleted_at` is null limit 1 | Bindings: [7] | Time: 8.74ms [2025-09-10 03:58:18] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.59ms [2025-09-10 03:58:18] local.INFO: SQL: select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`user_type` as `pivot_user_type`, `role_user`.`team_id` as `pivot_team_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ? and `role_user`.`user_type` = ? | Bindings: [7, App\Models\Admin] | Time: 0.66ms [2025-09-10 03:58:18] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.36ms [2025-09-10 03:58:18] local.INFO: SQL: select `schools`.*, `admin_school`.`admin_id` as `pivot_admin_id`, `admin_school`.`school_id` as `pivot_school_id` from `schools` inner join `admin_school` on `schools`.`school_id` = `admin_school`.`school_id` where `admin_school`.`admin_id` = ? and `schools`.`deleted_at` is null | Bindings: [7] | Time: 0.75ms [2025-09-10 03:58:18] local.INFO: SQL: select `users`.`full_name`, `users`.`email`, `users`.`mobile`, `users`.`profile_pic`, `users`.`user_id` from `users` where `preferred_school_id` = ? and `users`.`deleted_at` is null | Bindings: [2] | Time: 0.82ms [2025-09-10 03:58:18] local.INFO: SQL: select * from `users` where exists (select * from `schools` where `users`.`preferred_school_id` = `schools`.`school_id` and `preferred_school_id` = ? and `schools`.`deleted_at` is null) and `users`.`deleted_at` is null | Bindings: [2] | Time: 1.01ms [2025-09-10 03:58:18] local.INFO: SQL: select * from `users` where 0 = 1 and `users`.`deleted_at` is null | Bindings: [] | Time: 0.4ms [2025-09-10 03:58:18] local.INFO: SQL: select * from `calendars` where `group_id` = ? limit 1 | Bindings: [-1] | Time: 0.49ms [2025-09-10 03:58:18] local.INFO: SQL: select `attendances`.`attendance_id`, `attendances`.`user_id`, `attendances`.`group_id`, `attendances`.`date`, `attendances`.`present`, `attendances`.`holiday`, `attendances`.`attendance_updated_by_type`, `attendances`.`attendance_updated_by_id`, `attendances`.`created_at`, `attendances`.`updated_at`, `attendances`.`deleted_at` from `attendances` inner join (select `attendance_id`, `user_id`, `group_id`, `date`, FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') AS priority, ROW_NUMBER() OVER (PARTITION BY user_id, `date` ORDER BY FIELD(COALESCE(attendance_updated_by_type, ''), 'ADMIN', 'PARENT', 'CHILD', '') ASC) AS row_no from `attendances` where 0 = 1 and `group_id` in (?, ?) and `date` between ? and ? and `attendances`.`deleted_at` is null) as `sub` on `attendances`.`attendance_id` = `sub`.`attendance_id` where `sub`.`row_no` = ? and `attendances`.`deleted_at` is null | Bindings: [-1, -1, 2025-09-01 00:00:00, 2025-10-01 00:00:00, 1] | Time: 1.04ms [2025-09-10 07:05:03] local.INFO: SQL: select `tasks`.`task_id`, `tasks`.* from `tasks` left join `task_settings` on `tasks`.`task_id` = `task_settings`.`task_id` where MOD(DATEDIFF(CURRENT_DATE, tasks.created_at), task_settings.repeate_after_days) = 0 and `tasks`.`is_repeated` = ? and `tasks`.`due_by` >= CURRENT_DATE and `tasks`.`deleted_at` is null | Bindings: [] | Time: 26.36ms [2025-09-10 07:05:03] local.INFO: SQL: insert into `request_log` (`request_method`, `request_url`, `activity`, `user_id`, `query_params_json`, `client_ip`, `request_received_time`, `request_end_time`, `request_time_taken_ms`, `created_at`, `updated_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | Bindings: [GET, api/v2/create-repeate-tasks, General API request, , [], 198.12.221.39, 2025-09-10 07:05:03, 2025-09-10 07:05:03, 101, 2025-09-10 07:05:03, 2025-09-10 07:05:03] | Time: 3.54ms [2025-09-10 09:27:36] local.INFO: SQL: select `coins_for_college_role_id`, `role_name` from `coins_for_college_roles` where `coins_for_college_roles`.`deleted_at` is null | Bindings: [] | Time: 9.08ms [2025-09-10 09:27:36] local.INFO: SQL: insert into `request_log` (`request_method`, `request_url`, `activity`, `user_id`, `query_params_json`, `client_ip`, `request_received_time`, `request_end_time`, `request_time_taken_ms`, `created_at`, `updated_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | Bindings: [GET, api/get-coins-for-college-roles, General API request, , [], 20.171.207.210, 2025-09-10 09:27:36, 2025-09-10 09:27:36, 68, 2025-09-10 09:27:36, 2025-09-10 09:27:36] | Time: 3.63ms [2025-09-10 12:14:11] local.INFO: SQL: select `users`.*, (select count(*) from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `users`.`user_id` = `role_user`.`user_id` and `role_user`.`user_type` = ?) as `roles_count`, (select count(*) from `permissions` inner join `permission_user` on `permissions`.`id` = `permission_user`.`permission_id` where `users`.`user_id` = `permission_user`.`user_id` and `permission_user`.`user_type` = ?) as `permissions_count` from `users` where `users`.`deleted_at` is null limit 11 offset 0 | Bindings: [App\Models\User, App\Models\User] | Time: 60.52ms [2025-09-10 13:17:35] local.INFO: SQL: insert into `request_log` (`request_method`, `request_url`, `activity`, `user_id`, `query_params_json`, `client_ip`, `request_received_time`, `request_end_time`, `request_time_taken_ms`, `created_at`, `updated_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | Bindings: [GET, docu-locker.download.signed, General API request, , [], 20.171.207.210, 2025-09-10 13:17:35, 2025-09-10 13:17:35, 26, 2025-09-10 13:17:35, 2025-09-10 13:17:35] | Time: 9.58ms